IBM6250 Group Project - Coffee Vending
Introduction
Effective inventory control for coffee-vending machines hinges on anticipating weekly ingredient consumption while avoiding costly spoilage. We forecast demand using historical sales from two machines, delivering eight-week projections that guide stock levels and reorder cadence.
This report:
- Imports & cleans transaction data from two coffee-vending machines.
- Explores key demand drivers.
- Models weekly sales with Seasonal ARIMA (plus Prophet as a benchmark).
- Delivers eight-week forecasts and stocking recommendations.
Exploratory Data Analysis(EDA)
Model Evaluation and Diagnostics
Executive Summary with Actionable Recommendations
Appendix
Machine 1
Machine 1 Weekly ingredient demand vs. cups sold
Machine 2
Machine 2 Weekly ingredient demand vs. cups sold